-- Nix Tommy Lab 13

-- 1

	db.createView("BooksByPublisher", "Publisher",
		[
			{
				$lookup:
				{
					from: "Books",
					localField: "PubID",
					foreignField: "PubID",
					as: "BooksData"
				}
		},
		{
			$project:
				{
					_id: 0,
					Title: 1,
					BookTitle: "$BooksData.Title"
				}
		},
		{
			$unwind: "$BookTitle"
		}
	])
	
-- 2

	db.BooksByPublisher.find({Name: "AMERICAN PUBLISHING"}, {_id: 0})
	
-- 3
	db.BooksByPublisher.drop()
	
-- 4

	db.createView("CustomerByModel", "Customer",
		[
			{
				$lookup:
				{
					from: "VBAuto",
					localField: "InventoryIDNumber",
					foreignField: "InventoryID",
					as "ModelBought"
				}
			},
			{
				$project:
				{
					_id: 0,
					ModelName: 1,
					: "ModelBought.ModelName"
				}
		},
		{
			$unwind: "$ModelBought"
		}
	])
					
-- 5

	db.CustomerByModel.find({ModelName: "Suburban"}, {_id: 0})
	
-- 6

	db.CustomerByModel.drop()
	